/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50728
Source Host           : localhost:3306
Source Database       : litesql_test

Target Server Type    : MYSQL
Target Server Version : 50728
File Encoding         : 65001

Date: 2022-09-12 14:29:02
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `bs_order`
-- ----------------------------
DROP TABLE IF EXISTS `bs_order`;
CREATE TABLE `bs_order` (
  `id` varchar(50) NOT NULL COMMENT '主键',
  `order_time` datetime NOT NULL COMMENT '订单时间',
  `amount` decimal(20,2) DEFAULT NULL COMMENT '订单金额',
  `order_userid` bigint(20) NOT NULL COMMENT '下单用户',
  `status` tinyint(4) NOT NULL COMMENT '订单状态(0草稿 1已下单 2已付款 3已发货 4完成)',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_userid` varchar(50) NOT NULL COMMENT '创建者ID',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_userid` varchar(50) DEFAULT NULL COMMENT '更新者ID',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单表';

-- ----------------------------
-- Records of bs_order
-- ----------------------------
BEGIN;
INSERT INTO `bs_order` VALUES ('100001', '2022-01-19 12:04:42', '1393.50', '10', '0', '订单已修改56', '10', '2022-01-19 12:04:42', '10', '2022-09-11 19:32:57'), ('100002', '2022-01-19 12:05:23', '17268.42', '10', '0', '测试订单002', '10', '2022-01-19 12:05:23', null, null), ('100003', '2022-01-19 12:05:59', '17268.42', '10', '0', '测试订单003', '10', '2022-01-19 12:05:59', null, null), ('7f0ca7e8bb6c4f488c9b82f69a979fe6', '2022-09-11 19:32:55', '17268.42', '10', '0', null, '10', '2022-09-11 19:32:55', null, null), ('a428cc90850144e48237056104a6ce94', '2022-09-11 19:32:55', '17268.42', '10', '0', null, '10', '2022-09-11 19:32:55', null, null), ('f1f0ca6841b247f4a201c2902cef3cd2', '2022-09-11 19:32:55', '17268.42', '10', '0', null, '10', '2022-09-11 19:32:55', null, null);
COMMIT;

-- ----------------------------
-- Table structure for `bs_order_detail`
-- ----------------------------
DROP TABLE IF EXISTS `bs_order_detail`;
CREATE TABLE `bs_order_detail` (
  `id` varchar(50) NOT NULL COMMENT '主键',
  `order_id` varchar(50) NOT NULL COMMENT '订单ID',
  `goods_name` varchar(200) NOT NULL COMMENT '商品名称',
  `quantity` int(11) NOT NULL COMMENT '数量',
  `price` decimal(20,2) NOT NULL COMMENT '价格',
  `spec` varchar(100) DEFAULT NULL COMMENT '物品规格',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  `create_userid` varchar(50) NOT NULL COMMENT '创建者ID',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_userid` varchar(50) DEFAULT NULL COMMENT '更新者ID',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单明细表';

-- ----------------------------
-- Records of bs_order_detail
-- ----------------------------
BEGIN;
INSERT INTO `bs_order_detail` VALUES ('0c70c9e8a9624b3bbd6a67976a5bab1a', '7f0ca7e8bb6c4f488c9b82f69a979fe6', '鼠标', '12', '50.68', '个', '2', '10', '2022-09-11 19:32:55', null, null), ('10000201', '100002', '键盘', '11', '123.66', '个', '3', '10', '2022-01-19 12:05:23', null, null), ('10000202', '100002', '鼠标', '12', '50.68', '个', '2', '10', '2022-01-19 12:05:23', null, null), ('10000203', '100002', '电脑', '3', '5100.00', '台', '1', '10', '2022-01-19 12:05:23', null, null), ('10000301', '100003', '鼠标', '12', '50.68', '个', '2', '10', '2022-01-19 12:05:59', null, null), ('10000302', '100003', '电脑', '3', '5100.00', '台', '1', '10', '2022-01-19 12:05:59', null, null), ('10000303', '100003', '键盘', '11', '123.66', '个', '3', '10', '2022-01-19 12:05:59', null, null), ('16a211cfe1164197b23592c439559dec', 'f1f0ca6841b247f4a201c2902cef3cd2', '键盘', '11', '123.66', '个', '3', '10', '2022-09-11 19:32:55', null, null), ('2731be422841447d819a6eb5712e179b', 'f1f0ca6841b247f4a201c2902cef3cd2', '电脑', '3', '5100.00', '台', '1', '10', '2022-09-11 19:32:55', null, null), ('2d08d4ea6641447081ddcedb1404a757', 'a428cc90850144e48237056104a6ce94', '鼠标', '12', '50.68', '个', '2', '10', '2022-09-11 19:32:55', null, null), ('802d07cc26814b2e82794876b068b20e', 'a428cc90850144e48237056104a6ce94', '电脑', '3', '5100.00', '台', '1', '10', '2022-09-11 19:32:55', null, null), ('84b526a8d00e45b9b546f06c03f6e205', 'a428cc90850144e48237056104a6ce94', '键盘', '11', '123.66', '个', '3', '10', '2022-09-11 19:32:55', null, null), ('9acd3fa9b45f412397afef56ba4713de', '100001', '椅子74', '20', '30.23', '把', '5', '10', '2022-09-11 19:32:57', null, null), ('ac846c171ef54d39966416df62deb470', '7f0ca7e8bb6c4f488c9b82f69a979fe6', '键盘', '11', '123.66', '个', '3', '10', '2022-09-11 19:32:55', null, null), ('c67d3319dfc94174bdaca5aa76eddb7b', '7f0ca7e8bb6c4f488c9b82f69a979fe6', '电脑', '3', '5100.00', '台', '1', '10', '2022-09-11 19:32:55', null, null), ('d689026a18f54344a773672b33f831ef', '100001', '桌子82', '10', '78.89', '张', '4', '10', '2022-09-11 19:32:57', null, null), ('e284666ccbac4b33946d093187877fda', 'f1f0ca6841b247f4a201c2902cef3cd2', '鼠标', '12', '50.68', '个', '2', '10', '2022-09-11 19:32:55', null, null);
COMMIT;

-- ----------------------------
-- Table structure for `sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_name` varchar(50) NOT NULL COMMENT '用户名',
  `real_name` varchar(50) DEFAULT NULL COMMENT '用户姓名',
  `password` varchar(200) NOT NULL COMMENT '用户密码',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `create_userid` varchar(50) NOT NULL COMMENT '创建者ID',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_userid` varchar(50) DEFAULT NULL COMMENT '更新者ID',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=340012 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES ('1', 'admin', '超级管理员', '123456', '超级管理员', '1', '2020-11-01 13:39:43', '1', '2020-11-01 13:39:47'), ('2', 'admin2020', '普通管理员', '123456', '普通管理员', '1', '2020-11-01 13:42:55', '1', '2020-11-01 13:42:58'), ('9', 'wangwu', '王五', '123456', '测试修改用户02', '1', '2022-01-19 12:10:17', '1', null), ('10', 'zhangsan', '张三', '123456', '测试修改用户92', '1', '2020-11-01 13:40:30', '1', '2022-09-11 19:32:57'), ('11', 'lisi', '李四', '123456', '测试修改用户03', '1', '2020-11-01 13:42:08', '1', '2022-01-17 10:29:55'), ('12', 'testUser', '测试插入用户', '123456', null, '1', '2022-09-12 10:55:13', null, null);
COMMIT;

-- ----------------------------
-- Table structure for `sys_user_202208`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_202208`;
CREATE TABLE `sys_user_202208` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_name` varchar(50) NOT NULL COMMENT '用户名',
  `real_name` varchar(50) DEFAULT NULL COMMENT '用户姓名',
  `password` varchar(200) NOT NULL COMMENT '用户密码',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `create_userid` varchar(50) NOT NULL COMMENT '创建者ID',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_userid` varchar(50) DEFAULT NULL COMMENT '更新者ID',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of sys_user_202208
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_202208` VALUES ('1', 'admin', '超级管理员', '123456', '超级管理员', '1', '2020-11-01 13:39:43', '1', '2020-11-01 13:39:47'), ('2', 'admin2020', '普通管理员', '123456', '普通管理员', '1', '2020-11-01 13:42:55', '1', '2020-11-01 13:42:58'), ('9', 'wangwu', '王五', '123456', '测试修改用户02', '1', '2022-01-19 12:10:17', '1', '2022-08-01 16:18:15'), ('10', 'zhangsan', '张三', '123456', '测试修改分表数据21', '1', '2020-11-01 13:40:30', '1', '2022-09-11 19:32:57'), ('11', 'lisi', '李四', '123456', '测试修改用户03', '1', '2020-11-01 13:42:08', '1', '2022-01-17 10:29:55'), ('12', 'testUser', '测试插入分表数据', '123456', '测试插入分表数据', '1', '2022-08-01 20:38:22', null, null), ('13', 'testUser', '测试插入分表数据', '123456', '测试插入分表数据', '1', '2022-08-01 20:43:18', null, null), ('14', 'testUser', '测试插入分表数据', '123456', '测试插入分表数据', '1', '2022-08-01 20:51:12', null, null), ('15', 'testUser', '测试插入分表数据', '123456', '测试插入分表数据', '1', '2022-08-01 22:48:44', null, null), ('16', 'testUser', '测试插入分表数据', '123456', '测试插入分表数据', '1', '2022-08-04 12:12:06', null, null), ('17', 'testUser', '测试插入分表数据', '123456', '测试插入分表数据', '1', '2022-08-04 12:40:18', null, null), ('18', 'testUser', '测试插入分表数据', '123456', '测试插入分表数据', '1', '2022-08-04 12:46:31', null, null), ('19', 'testUser', '测试插入分表数据', '123456', '测试插入分表数据', '1', '2022-08-04 12:49:33', null, null), ('20', 'testUser', '测试插入分表数据', '123456', '测试插入分表数据', '1', '2022-08-04 13:21:02', null, null);
COMMIT;
